﻿CREATE TABLE [dbo].[HostedService] (
    [HostedServiceId] UNIQUEIDENTIFIER CONSTRAINT [DF_HostedService_HostedServiceId] DEFAULT (newid()) ROWGUIDCOL NOT NULL,
    [AffinityGroupId] UNIQUEIDENTIFIER NULL,
    [LocationId]      UNIQUEIDENTIFIER NULL,
    [Name]            VARCHAR (150)    NOT NULL,
    [Label]           VARCHAR (150)    NOT NULL,
    [URI]             VARCHAR (500)    NOT NULL,
    CONSTRAINT [PK_HostedService] PRIMARY KEY CLUSTERED ([HostedServiceId] ASC)
);

